Tabela UserGroup

Definicja tabeli UserGroup

Name

UserGroup

Code

UserGroup

Comment

 


Lista kolumn tabeli UserGroup

Name

Code

ID

ID

HospID

HospID

ExtID

ExtID

Descr

Descr

Active

Active

UpdUserID

UpdUserID

UpdNr

UpdNr

UpdDate

UpdDate

UpdTime

UpdTime

LockUserID

LockUserID

LockTime

LockTime

AccountNo

AccountNo

CustomerContractNo

CustomerContractNo


Kolumna ID tabeli UserGroup

Definicja kolumny ID tabeli UserGroup

Name

ID

Code

ID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna HospID tabeli UserGroup

Definicja kolumny HospID tabeli UserGroup

Name

HospID

Code

HospID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna ExtID tabeli UserGroup

Definicja kolumny ExtID tabeli UserGroup

Name

ExtID

Code

ExtID

Data Type

VARCHAR2(60)

Mandatory

No

Comment

 


Kolumna Descr tabeli UserGroup

Definicja kolumny Descr tabeli UserGroup

Name

Descr

Code

Descr

Data Type

VARCHAR2(256)

Mandatory

No

Comment

 


Kolumna Active tabeli UserGroup

Definicja kolumny Active tabeli UserGroup

Name

Active

Code

Active

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna UpdUserID tabeli UserGroup

Definicja kolumny UpdUserID tabeli UserGroup

Name

UpdUserID

Code

UpdUserID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna UpdNr tabeli UserGroup

Definicja kolumny UpdNr tabeli UserGroup

Name

UpdNr

Code

UpdNr

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna UpdDate tabeli UserGroup

Definicja kolumny UpdDate tabeli UserGroup

Name

UpdDate

Code

UpdDate

Data Type

DATE

Mandatory

No

Comment

 


Kolumna UpdTime tabeli UserGroup

Definicja kolumny UpdTime tabeli UserGroup

Name

UpdTime

Code

UpdTime

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna LockUserID tabeli UserGroup

Definicja kolumny LockUserID tabeli UserGroup

Name

LockUserID

Code

LockUserID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna LockTime tabeli UserGroup

Definicja kolumny LockTime tabeli UserGroup

Name

LockTime

Code

LockTime

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna AccountNo tabeli UserGroup

Definicja kolumny AccountNo tabeli UserGroup

Name

AccountNo

Code

AccountNo

Data Type

VARCHAR2(32)

Mandatory

No

Comment

 


Kolumna CustomerContractNo tabeli UserGroup

Definicja kolumny CustomerContractNo tabeli UserGroup

Name

CustomerContractNo

Code

CustomerContractNo

Data Type

VARCHAR2(24)

Mandatory

No

Comment

 


Lista kluczy tabeli UserGroup

Name

Code

Primary

PK_UserGroup_ID

PK_UserGroup_ID

X


Klucz PK_UserGroup_ID tabeli UserGroup

Definicja klucza PK_UserGroup_ID tabeli UserGroup

Name

PK_UserGroup_ID

Code

PK_UserGroup_ID

Primary

Yes

Comment